
	
/****** Object:  Stored Procedure [dbo].GiftsUpdate    Script Date: Monday, July 27, 2009 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spGiftsUpdate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[spGiftsUpdate]
GO
			
	
	

	
/******************************************************************************
**		File: 
**		Name: [dbo].spGiftsUpdate
**		Desc: 
**
**		Return values:
** 
**		Called by:   
**              
**		Parameters:
**		Input							Output
**     ----------							-----------
**
**		Auth: CodeSmith
**		Date: 7/27/2009 4:18:20 PM
*******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:				Description:
**		--------		--------				-------------------------------------------
**    
*******************************************************************************/
CREATE PROCEDURE [dbo].spGiftsUpdate
	@GiftId int, 
	@Name nvarchar(50), 
	@Price int, 
	@Description ntext, 
	@CreationDate datetime 
AS

UPDATE [dbo].[Gifts] SET
	[Name] = @Name,
	[Price] = @Price,
	[Description] = @Description,
	[CreationDate] = @CreationDate
WHERE
	[GiftId] = @GiftId

GO

